Skip Headers

Oracle® C++ Call Interface Programmer's Guide 10g Release 2 (10.2) Part Number B14294-02 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F H I L M N O P Q R S T U V X

## A

  Agent class, 12
    methods, 12
  AnyData class, 12
    methods, 12
    supported datatypes, 12
    usage examples, 12
  application managed data buffering, 11.4
  application-provided serialization, 11.3.3.2
  associative access
    overview, 4.6
  atomic null, 4.9.2
  attributes, 1.5
  automatic serialization, 11.3.3.1

## B

  BatchSQLException
    methods, 12
  BatchSQLException class, 12
  Bfile class, 12
    methods, 12
  BFILEs
    external datatype, 5.3.1.1
  bind operations
    in bind operations, 1.4
    out bind operations, 1.4
  Blob class, 12
    methods, 12
  BLOBs
    external datatype, 5.3.1.4
  Bytes class, 12
    methods, 12

## C

  callable statements, 3.4.3
    with arrays as parameters, 3.4.3.1
  CASE OTT parameter, 7.4.3.2
  CHAR
    external datatype, 5.3.1.5
  classes
    Agent class, 12
    AnyData class, 12
    BatchSQLException class, 12
    Bfile class, 12
    Blob class, 12
    Bytes class, 12
    Clob class, 12
    Connection class, 12
    ConnectionPool class, 12
    Consumer class, 12
    Date class, 12
    Environment class, 12
    IntervalDS class, 12
    IntervalYM class, 12
    Listener class, 12
    Map class, 12
    Message class, 12
    Metadata class, 12
    NotifyResult class, 12
    Number class, 12
    PObject class, 12
    Producer class, 12
    Ref class, 12
    RefAny class, 12
    ResultSet class, 3.5.1, 12
    SQLException class, 12
    StatelessConnectionPool class, 12
    Statement class, 12
    Stream class, 12
    Subscription class, 12
    Timestamp class, 12
  Clob class, 12
    methods, 12
  CLOBs
    external datatype, 5.3.1.7
  CODE OTT parameter, 7.4.3.3
  collections
    working with, 4.9
  committing a transaction, 3.7
  complex object retrieval
    complex object, 4.8
    depth level, 4.8
    implementing, 4.8.1
    overview, 4.8
    prefetch limit, 4.8
    root object, 4.8
  complex objects, 4.8
    prefetching, 4.8.2
    retrieving, 4.8.1
  CONFIG OTT parameter, 7.4.3.4
  configuration files
    and the OTT utility, 7.4
  connecting to a database, 3.1
  Connection class, 12
    methods, 12
  connection pool
    createConnectionPool method, 3.2.1.1
    creating, 3.2.1, 3.2.1.1
  connection pooling, 3.2
    transparent application failover, 11.2.3
  ConnectionPool class, 12
    methods, 12
  Consumer class, 12
    methods, 12
  control statements, 1.2.2

## D

  data buffering, 11.4
  data conversions
    Date, 5.4.2
    DATE datatype, 5.4.2
    internal datatypes, 5.4, 5.4
    Interval, 5.4.2
    INTERVAL datatypes, 5.4.2
    LOB datatype, 5.4.1
    LOBs, 5.4.1
    Timestamp, 5.4.2
    TIMESTAMP datatypes, 5.4.2
  database
    connecting to, 3.1
  datatypes, 5
    AnyData, 12
    OTT mappings, 7.6
    overview, 5.1
    types
      external datatypes, 5.1, 5.3
      internal datatypes, 5.1, 5.2
  DATE
    external datatype, 5.3.1.8
      data conversion, 5.4.2
  Date class, 12
    methods, 12
    usage examples, 12
  DDL statements
    executing, 3.3
  depth level, 4.8
  DML statements
    executing, 3.3

## E

  elements, 1.1.4
  embedded objects, 4.2.1
    creating, 4.2.1
    fetching, 4.9.1
    prefetching, 4.9.1
  Environment class, 12
    methods, 12
  ERRTYPE OTT parameter, 7.4.3.6
  examples
    Date class, 12
    IntervalDS class, 12
    IntervalYM class, 12
    Number class, 12
  exception handling, 3.9
  executing SQL queries, 3.5
  executing statements dynamically, 3.6
  external datatypes, 5.3.1
    BFILE, 5.3.1.1
    BLOB, 5.3.1.4
    CHAR, 5.3.1.5
    CHARZ, 5.3.1.6
    CLOB, 5.3.1.7
    DATE, 5.3.1.8
    FLOAT, 5.3.1.9
    INTEGER, 5.3.1.10
    INTERVAL DAY TO SECOND, 5.3.1.11
    INTERVAL YEAR TO MONTH, 5.3.1.12
    LONG, 5.3.1.13
    LONG RAW, 5.3.1.14
    LONG VARCHAR, 5.3.1.15
    LONG VARRAW, 5.3.1.16
    NCLOB, 5.3.1.17
    NUMBER, 5.3.1.18
    OCCI BFILE, 5.3.1.19
    OCCI BLOB, 5.3.1.20
    OCCI BYTES, 5.3.1.21
    OCCI CLOB, 5.3.1.22
    OCCI DATE, 5.3.1.23
    OCCI INTERVALDS, 5.3.1.24
    OCCI INTERVALYM, 5.3.1.25
    OCCI NUMBER, 5.3.1.26
    OCCI POBJECT, 5.3.1.27
    OCCI REF, 5.3.1.28
    OCCI REFANY, 5.3.1.29
    OCCI STRING, 5.3.1.29
    OCCI TIMESTAMP, 5.3.1.31
    OCCI VECTOR, 5.3.1.32
    RAW, 5.3.1.33
    REF, 5.3.1.34
    ROWID, 5.3.1.35
    STRING, 5.3.1.36
    TIMESTAMP, 5.3.1.37
    TIMESTAMP WITH LOCAL TIME ZONE, 5.3.1.38
    TIMESTAMP WITH TIME ZONE, 5.3.1.39
    UNSIGNED INT, 5.3.1.40
    VARCHAR, 5.3.1.41
    VARCHAR2, 5.3.1.41
    VARNUM, 5.3.1.43
    VARRAW, 5.3.1.44

## F

  fields
    IntervalDS class, 12
    IntervalYM class, 12
    Timestamp fields, 12
  FLOAT
    external datatype, 5.3.1.9

## H

  HFILE OTT parameter, 7.4.3.7

## I

  Instant Client, 2.4
    benefits, 2.4.1
    connection names, 2.4.6
    database connection, 2.4.6
    environment variables, 2.4.7
      Solaris, 2.4.7
      Windows, 2.4.7
    installation, 2.4.2
    libraries, 2.4.4
      Data Shared Library, 2.4.5
      patching, 2.4.4
      regenerating, 2.4.5
    patching libraries, 2.4.4
    SDK, 2.4.2.1.1
    using, 2.4.3
  Instant Client Light (English), 2.5
    character sets, 2.5.1
    errors, 2.5.1
    globalization settings, 2.5.1
    installation, 2.5.3
      Client Admin Install, 2.5.3.2
      Oracle Universal Installer, 2.5.3.3
      OTN download, 2.5.3.1
    using, 2.5.2
  INTEGER
    external datatype, 5.3.1.10
  internal datatypes, 5.2
    CHAR, 5.2.1
    LONG, 5.2.1
    LONG RAW, 5.2.1
    RAW, 5.2.1
    VARCHAR2, 5.2.1
  INTERVAL DAY TO SECOND
    external datatype, 5.3.1.11
  INTERVAL YEAR TO MONTH
    external datatype, 5.3.1.12
  IntervalDS class, 12
    fields, 12
    methods, 12
    usage examples, 12
  IntervalYM class, 12
    fields, 12
    methods, 12
    usage examples, 12
  INTYPE file
    structure of, 7.5.2
  INTYPE OTT parameter, 7.4.3.8

## L

  Listener class, 12
    methods, 12
  LOBs
    external datatype
      data conversion, 5.4.1
  LONG
    external datatype, 5.3.1.13
  LONG RAW
    external datatype, 5.3.1.14
  LONG VARCHAR
    external datatype, 5.3.1.15

## M

  manipulating object attributes, 4.7.3
  Map class, 12
    methods, 12
  Message class, 12
    methods, 12
  metadata
    code example, 6.2.1
    describing database objects, 6.2
    overview, 6.1
  MetaData class, 12
    methods, 12
  methods, 1.5
    Agent methods, 12
    AnyData methods, 12
    BatchSQLException methods, 12
    Bfile methods, 12
    Blob methods, 12
    Bytes methods, 12
    Clob methods, 12
    Connection methods, 12
    ConnectionPool methods, 12
    Consumer methods, 12
    createConnection method, 3.1.2, 3.1.2
    createConnectionPool method, 3.2.1.1
    createEnvironment method, 3.1.1
    createProxyConnection method, 3.2.1.2, 3.2.1.2
    createStatement method, 3.3.1
    Date methods, 12
    Environment class, 12
    execute method, 3.3.2
    executeArrayUpdate method, 3.3.2, 11.4.2
    executeQuery method, 3.3.2
    executeUpdate method, 3.3.2
    IntervalDS methods, 12
    IntervalYM class, 12
    Listener methods, 12
    Map methods, 12
    Message methods, 12
    MetaData class, 12
    NotifyResult methods, 12
    Number class, 12
    PObject methods, 12
    Producer methods, 12
    Ref methods, 12
    RefAny methods, 12
    ResultSet methods, 12
    setDataBuffer method, 11.4.1
    SQLException methods, 12
    StatelessConnectionPool, 12
    Statement, 12
    Stream methods, 12
    Subscription methods, 12
    terminateConnection method, 3.1.2, 3.1.2
    terminateEnvironment method, 3.1.2
    terminateStatement method, 3.3.4
    Timestamp methods, 12
  modifying rows iteratively, 11.6

## N

  navigational access
    overview, 4.7
  NCLOBs
    external datatype, 5.3.1.17
  NEEDS_STREAM_DATA status, 3.6.1, 3.6.1.5
  new features
    Oracle Database 10g Release 1 (10.1), Preface
    Oracle Database 10g Release 2 (10.2), Preface
  nonprocedural elements, 1.1.4
  nonreferenceable objects, 4.2.1
  NotifyResult class, 12
    methods, 12
  nullness, 4.9.2
  NUMBER
    external datatype, 5.3.1.18
  Number class, 12
    methods, 12
    usage examples, 12

## O

  object cache, 4.4.2.1, 4.4.2.3
    flushing, 4.4.2.4
  object mode, 4.4.2.1
  object programming
    overview, 4.1
    using OCCI, 4
  object references
    using, 4.10
    see also REF
  Object Type Translator utility
    see OTT utility
  object types, 1.5
  objects
    access using SQL, 4.6.1
    attributes, 1.5
    client-side, 1.5.1
    dirty, 4.7.5
    environment, 1.5.2
    flushing, 4.7.4
    freeing, 4.10
    in OCCI, 4.2
    inserting, 4.6.2
    interfaces, 1.5.3
      associative, 1.5.3
      navigational, 1.5.3
    manipulating attributes, 4.7.3
    marking, 4.7.4
    Metadata Class, 1.5.4
    methods, 1.5
    modifying, 4.6.2
    object cache, 1.5.1
    object types, 1.5
    pinned, 4.7.2
    pinning, 4.4.2.2, 4.7.2, 4.7.2
    recording database changes, 4.7.6
    runtime environment, 1.5.2
    transparent application failover, 11.2.2
  OCCI
    benefits, 1.1.1
    building applications, 1.1.2
    functionality, 1.1.3
    object mode, 4.4.2.1
    overview, 1.1
    special SQL terms, 1.4
  OCCI classes
    Agent class, 12
    AnyData class, 12
    BatchSQLException class, 12
    Bfile class, 12
    Blob class, 12
    Bytes class, 12
    Clob class, 12
    Connection class, 12
    ConnectionPool class, 12
    Consumer class, 12
    Data class, 12
    Environment class, 12
    IntervalDS class, 12
    IntervalYM class, 12
    Listener class, 12
    Map class, 12
    Message class, 12
    MetaData class, 12
    NotifyResult class, 12
    Number class, 12
    PObject class, 12
    Producer class, 12
    Ref class, 12
    RefAny class, 12
    ResultSet class, 12
    SQLException class, 12
    StatelessConnectionPool class, 12
    Statement class, 12
    Stream class, 12
    Subscription class, 12
    Timestamp class, 12
  OCCI environment
    connection pool, 3.2.1
    creating, 3.1.1, 3.1.1
    opening a connection, 3.1.1, 3.1.2
    scope, 3.1.1, 3.1.1
    terminating, 3.1, 3.1.1
  OCCI program
    example of, 4.13
  OCCI program development, 4.4
    operational flow, 4.4.2
    program structure, 4.4.1
  OCCI types
    data conversion, 5.1.1
  optimizing performance, 3.5.3
    setting prefetch count, 3.5.3
  OTT parameter TRANSITIVE, 7.4.3.13
  OTT parameters
    CASE, 7.4.3.2
    CODE, 7.4.3.3
    CONFIG, 7.4.3.4
    ERRTYPE, 7.4.3.6
    HFILE, 7.4.3.7
    INTYPE, 7.4.3.8
    OUTTYPE, 7.4.3.11
    SCHEMA_NAMES, 7.4.3.12
    USERID, 7.4.3.15, 7.4.3.16
    where they appear, 7.4.4
  OTT utility
    benefits, 1.5.5
    creating types in the database, 7.3
    default name mapping, 7.6.1
    description, 1.5.5
    parameters, 7.4.3
    using, 7.2
  out bind variables, 1.3
  OUTTYPE OTT parameter, 7.4.3.11

## P

  parameterized statements, 3.4.2
  performance
    optimizing
      executeArrayUpdate method, 11.4.2
      setDataBuffer method, 11.4.1
  performance tuning
    application managed data buffering, 11.4
    array fetch using next() method, 11.5
    data buffering, 11.4
  performance tunning, 11
    connection sharing, 11.3
    reading and writing multiple LOBs, 11.1
    shared server environments, 11.3.1
      thread safety, 11.3.1
    thread safety, 11.3.1
    transparent application failover, 11.2
  persistent objects, 4.2, 4.2.1
    creating, 4.3.1
    standalone objects, 4.2.1
    types
      embedded objects, 4.2.1
      nonreferenceable objects, 4.2.1
      referenceable objects, 4.2.1
      standalone objects, 4.2.1
  pinning objects, 4.4.2.2, 4.7.2
  PL/SQL
    out bind variables, 1.3
    overview, 1.3
  PObject class, 12
    methods, 12
  prefetch count
    set, 3.5.3
  prefetch limit, 4.8
  PREPARED status, 3.6.1, 3.6.1.2
  procedural elements, 1.1.4
  Producer class, 12
    methods, 12
  proxy connections, 3.2.1.2
    using createProxyConnection method, 3.2.1.2

## Q

  queries, 1.2.4
    how to specify, 3.5.2

## R

  RAW
    external datatype, 5.3.1.33, 5.3.1.33
  REF
    external datatype, 5.3.1.34
    retrieving a reference to an object
  Ref class, 12
    methods, 12
  RefAny class, 12
    methods, 12
  referenceable objects, 4.2.1
  relational programming
    using OCCI, 3
  RESULT_SET_AVAILABLE status, 3.6.1, 3.6.1.3
  ResultSet class, 3.5.1, 12
    methods, 12
  root object, 4.8
  ROWID
    external datatype, 5.3.1.35
  rows
    iterative modification, 11.6
    modify, 11.6

## S

  SCHEMA_NAMES OTT parameter, 7.4.3.12
  shared connections
    using, 11.3
  shared server environments
    application-provided serialization, 11.3.3.2
    automatic serialization, 11.3.3.1
    concurrency, 11.3.3.2
    thread safety, 11.3.1
      implementing, 11.3.2
  SQL statements
    control statements, 1.2.2
    DML statements, 1.2.3
    processing of, 1.2
    queries, 1.2.4
    types
      callable statements, 3.4, 3.4.3
      parameterized statements, 3.4, 3.4.2
      standard statements, 3.4, 3.4.1
  SQLException class, 12
    methods, 12
  standalone objects, 4.2.1
    creating, 4.2.1
  standard statements, 3.4.1
  StatelessConnectionPool class, 12
    methods, 12
  statement caching, 3.8
  Statement class, 12
    methods, 12
  statement handles
    creating, 3.3.1, 3.3.1, 3.3.2
    reusing, 3.3.3
    terminating, 3.3.4
  status
    NEEDS_STREAM_DATA, 3.6.1, 3.6.1.5
    PREPARED, 3.6.1, 3.6.1.2
    RESULT_SET_AVAILABLE, 3.6.1, 3.6.1.3
    STREAM_DATA_AVAILABLE, 3.6.1, 3.6.1.6
    UNPREPARED, 3.6.1, 3.6.1.1
    UPDATE_COUNT_AVAILABLE, 3.6.1, 3.6.1.4
  Stream class, 12
    methods, 12
  STREAM_DATA_AVAILABLE status, 3.6.1, 3.6.1.6
  streamed reads, 3.4.4
  streamed writes, 3.4.4
  STRING
    external datatype, 5.3.1.36
  Subscription class, 12
    methods, 12
  substitutability, 4.12.1

## T

  thread safety, 11.3.1
    implementing, 11.3.2
  TIMESTAMP
    external datatype, 5.3.1.37
  Timestamp class
    methods, 12
  TIMESTAMP WITH LOCAL TIME ZONE
    external datatype, 5.3.1.38
  TIMESTAMP WITH TIME ZONE
    external datatype, 5.3.1.39
  transient objects, 4.2, 4.2.2
    creating, 4.2.2, 4.3.1
  TRANSITIVE OTT parameter, 7.4.3.13
  transparent application failover, 11.2
    connection pooling, 11.2.3
    objects, 11.2.2
    using, 11.2.1
  type inheritance, 4.12, 4.12.3, 4.12.4

## U

  UNPREPARED status, 3.6.1, 3.6.1.1
  UNSIGNED INT
    external datatype, 5.3.1.40
  UPDATE_COUNT_AVAILABLE status, 3.6.1, 3.6.1.4
  USERID OTT parameter, 7.4.3.15, 7.4.3.16

## V

  values
    in context of this document, 4.2.3
    in object applications, 4.2.3
  VARCHAR
    external datatype, 5.3.1.41
  VARCHAR2
    external datatype, 5.3.1.41
  VARNUM
    external datatype, 5.3.1.43
  VARRAW
    external datatype, 5.3.1.16, 5.3.1.44

## X

  XA library, 10